Hands-Off Spreadsheets

نویسنده

  • Colin A. Kerr
چکیده

The wealth of functionality in the Excel software package means it can go beyond use as a static evaluator of predefined cell formulae, to be used actively in manipulating and transforming data. Due to human error it’s impossible to ensure a process like this is always error free, and frequently the sequence of actions is recorded only in the operator’s head. If done regularly by highly paid staff it will be expensive. This paper applies to those spreadsheets which involve significant operator intervention, describes a method that has been used to improve reliability and efficiency, and reports on how it has worked in practice.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

MODFLOW 2001 and Other Modeling Odysseys Proceedings, 2001, International Ground Water Modeling Center, Colorado School of Mines, Golden, CO, p. 815-822 The Power of Spreadsheet Models

Prior to using MODFLOW, students need experience with simpler codes that provide “hands-on” experience setting up boundary and initial conditions, coding simple solution algorithms, and handling numerical errors. The best way to do this is using spreadsheet models; faculty no longer can expect students to know a common computer language, but students are familiar with spreadsheets. Many aspects...

متن کامل

مقایسه میزان صدمات پرینه در کنترل پرینه با دست و بدون کاربرد دست حین زایمان

Background and purpose: Perineal lacerations are common complications of normal vaginal delivery which influence maternal health and quality of life of mothers. This study aimed at comparing perineal protection using hands on and hands off techniques on perineal lacerations during delivery. Material and Methods: This clinical trial included 600 nulliparous women who were randomly divided into ...

متن کامل

2005: Combining Hands-On, Spreadsheet and Discrete Event Simulation to Teach Supply Chain Management

This paper describes the effect of combining hands-on simulation with spreadsheets and discrete event simulations. These tools enhance the student learning process of supply chain management principles. Active, hands-on learning is one of the most effective types of learning but is very time consuming. Supplementing it with computer simulation enhances the hands-on learning to cover more materi...

متن کامل

Automating Spreadsheet Discovery & Risk Assessment

There have been many articles and mishaps published about the risks of uncontrolled spreadsheets in today’s business environment, including non-compliance, operational risk, errors, and fraud all leading to significant loss events. Spreadsheets fall into the realm of end user developed applications and are often absent the proper safeguards and controls an IT organization would enforce for ente...

متن کامل

How do Range Names Hinder Novice Spreadsheet Debugging Performance?

Although experts diverge on how best to improve spreadsheet quality, it is generally agreed that more time needs to be spent testing spreadsheets. Ideally, experienced and trained spreadsheet engineers would carry this out, but quite often this is neither practical nor possible. Many spreadsheets are a legacy, developed by staff that have since moved on, or indeed modified by many staff no long...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:
  • CoRR

دوره abs/1210.5262  شماره 

صفحات  -

تاریخ انتشار 2012